<?php
/**
 * Copyright (c) 2010, Slawomir Mazur <mazursllawek@gmail.com>
 * 
 * All rights reserved.
 * 
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted provided that the following conditions 
 * are met:
 * 
 * o Redistributions of source code must retain the above copyright notice, 
 *   this list of conditions and the following disclaimer.
 * o Redistributions in binary form must reproduce the above copyright notice,
 *   this list of conditions and the following disclaimer in the documentation
 *   and/or other materials provided with the distribution.
 * o Neither the name of the Softisland nor the names of its contributors
 *   may be used to endorse or promote products derived from this software
 *   without specific prior written permission.
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS 
 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT 
 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR 
 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT 
 * HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, 
 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT 
 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, 
 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY 
 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT 
 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE 
 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 */
/**
 * Enter description here...
 *
 * @package     System
 * @copyright   Slawomir Mazur (c) 2010 (http://www.zend.com/zce.php?c=ZEND011643)
 * @license     http://www.opensource.org/licenses/bsd-license.php
 * @author      Slawomir Mazur <mazursllawek@gmail.com>
 */

require_once 'Library.php';

class System_Model_History extends Zend_Db_Table_Abstract
{
	const CACHE_TAGS = 'HISTORY';
	
	protected $_name = 'history';
	
	protected $_primary = 'history_id';
	
	protected $_collection = null;
	
	public function getName()
	{
		return $this->_name;
	}
	
	public function getCollection()
	{
		return $this->fetchAll($select);
	}
	
	public function loadMostUpdateGeneData($value, $attribute, $year = Gp_View_Helper_Library::LATEST)
	{
		$value = (string) $value;
		
		// attribute id
		$attribute = (int) $attribute;
		
		if (empty($value)) {
			throw new Exception('Empty value');
		}
		
		// load newest library ids from database
		$subSelect = $this->getAdapter()->select();
		$subSelect->from('library', array('library_id', 'company_id'))
			->where('company_id IS NOT NULL')
			->where('status = ?', System_Model_Library::READED, Zend_Db::INT_TYPE)
			->order('created_at DESC');

		// if year was selected
		if (Gp_View_Helper_Library::LATEST != $year) {
			$subSelect->where('YEAR(created_at) = ?', $year, Zend_Db::INT_TYPE);
		}

		$select = $this->getAdapter()->select();
		$select->from($subSelect)
			->group('company_id');
			
		$libraryIds = $this->getAdapter()->fetchCol($select);
		
		if (!(count($libraryIds) > 0)) {
			return array();
		}

		/* @var $attributeModel System_Model_Attribute */
		$attributeModel = Gp_App::getModel('system/attribute');
		$mapping = $attributeModel->getAttributesMapping();
		
		// load lines which includes given value and are from library
		$select = $this->select();
		
		// parse attributes if not empty
		$session = new Zend_Session_Namespace('navigationSession');
		$attributesToSelect = $session->attributesToSelect;
		if (!empty($attributesToSelect)) {
			// add to standard columns which are library_id and currently searched value
			$attributesToSelect[] = 'library_id';
			$attributesToSelect[] = $mapping[$attribute]['code'];
			
			$select->from($this->_name, $attributesToSelect);
		} else {
			$select->from($this->_name);
		}
		$select->where('library_id IN (?)', $libraryIds)
			->where($mapping[$attribute]['code'] . " LIKE ?", $value . '%')
			->order(array('library_id', 'gene_id', 'gene_symbol'));
			
		$result = $this->fetchAll($select);
		
		if (!($result->count() > 0)) {
			$result = array();
		}
		
		return $result;
	}
}